Version 2022 R1.3

Web Server Build Number: 22.1.3.10160
Excel Add-in Build Number: 22.1.3.10160
DataSync Build Number: 22.1.3.10150
October 18, 2022

Breaking Changes

• As of the last release for the year 2022, we will no longer support the 32-bit version of Excel Add-in for Windows 32 bits. The Nectari Excel Add-in - WIN32.exe installation package will not be available. You will need Windows 64 bits in order to install Excel Add-in for MS-Office 32-bit or 64-bit version (Excel Add-in - WIN64.exe).
• Oracle users must now be created before installing Nectari.
• As of October 10, 2023, Windows Server 2012 R2 will no longer be supported by Microsoft nor by Nectari.

Improvements

Installation

• New scripts are available to create Oracle and SQL users. Oracle users must now be created before installing Nectari. The installation steps of the Nectari License Server and Central Point have been updated to include these users by default. 14422
• Installation log files are consolidated and saved in the same location defined as installation path at the beginning of the basic or advanced server installation. 11991
• Ports are validated during the installation to make sure they are not already used by other hosts. 13096
• Nectari installation packages are now automatically run as an Administrator. You no longer need to right-click the .exe file and select this option. However, your Windows user must have Administrator rights. 14339

Web Client

• The new Edit Advanced Filter data model role has been added to views. 14419
• Wildcards can now be used to filter values in Reporting Trees. 15116
• For worksheets and reports, a new option to enable or disable the outline has been added to the Excel Export tab. 13273
• Improvements to the Web Workbook (Preview):
  • Several currencies have been added to the workbook. 13075
  • Workbook components are now translated in all languages supported by Nectari. 13145
  • Workbook folders can now be renamed. 13171
  • Workbooks can now be renamed using a shortcut. 13172
  • Workbook context menus have been enhanced so that the text is displayed properly when the language is French. 13178
  • In the formula wizard, the display of fields available for selection in the filter has been improved. 13187
  • A workbook item can now be set as a landing page. 3652
• You can now customize the web application content security; refer to this procedure. 14085

OLAP Manager

• When creating a cube, the table name is now verified to avoid duplicate names. 13339

Distribution

• The Scheduler now allows you to use the Run As option without having to add any users or groups to send emails using external addresses. 4430
• The Scheduler history has been improved to display more log details on failures. 13256

Excel Add-in

• Wildcards can now be used to filter values in reporting trees, pivots, data extractions, and formulas. 15417
• The new Refresh Style drop-down has been added to data extractions. 14068

DataSync

• A new Execution Timeout option has been added to extractions. 12864

Web Client Templates

Template	Change description
Primavera	- The Primavera template is now available.
Sage Intacct	- The Web Workbook (Preview) now includes Income Statement and Balance Sheet templates. - New tables have been added to DataSync extractions, including Gcbook and Uomdetail. - The global consolidation module has been optimized for better performance and user experience. - Global variables have been added to the Consolidation module to:   • Enable users to dynamically change which consolidation books are available;   • Add information to measures for better clarity (consolidation currency, book ID). - Refresh jobs can now be scheduled for Opening Balance and Exchange Rates using the OLAP Manager. - Dashboards have been added to the Finance (Income Statement), AP, AR, Order Entry, and Inventory modules. - The documentation has been updated with procedures to configure the Finance module, a new section on Book Exchange Rates, and a new step to configure report codes.
Sage X3	- The Web Workbook (Preview) now includes Income Statement and Balance Sheet templates. - The Invoice Analysis with Kit Margin Calculation data model has been added to the Sales templates. - A stored procedure (HISTODUDOPEN_CALC) has been added to the AP/AR Historical Aging data model.
Sage 300	- The Web Workbook (Preview) now includes Income Statement and Balance Sheet templates. - Calendar month and year dimensions have been added to the template.
UDM	- The Sage Intacct Consolidation module now supported in the UDM.

Fixes

Web Client

• Sorting a view that contained a Pivot with Advanced Options was sometimes not applied. 15101
• Subtotal Restrictions were sometimes not applied when exporting the view to an Excel file. 15045
• Improvements were made to add more security to the cookies used in the Web application. 14084
• These defects have been fixed in the Web Workbook (Preview):
  • The formula wizard would sometimes fail when a formula was set to create a dynamic list and was filtering on a number in an Oracle environment. 11806
  • The formula wizard would sometimes return an error if the formula was using a table whose name contained a space. 14184
• After adding multiple dockable filters to a dashboard and saving it, only the first filter was saved. 15174
• The Reporting Tree Node comment was sometimes not saved. 14789
• The look and feel of external links has been fixed so as to be consistent with the Web Client. 13453
• French accent characters in view, dashboard, and report names were not showing properly in the mobile version of Web Client. 15094
• For on premise installations, the Web application would sometimes take longer to start when set up in HTTPS. 13972

OLAP Manager

• After saving a new job, the time displayed in the Next Run Date column was in UTC instead of the local time zone. After the initial job run, the time would be displayed correctly. 15382

Distribution

• When a job included several Excel Add-in views to be distributed, the job would sometimes fail. 13415

Excel Add-in

• When a dimension name contained a single quote or a range with one or two asterisks (*), the formula wizard could not return the correct value. 15117
• Using a prompt or a quick prompt would return an error when the Data Model had field names using SQL Reserved Keywords. 11738
• Distributing a spreadsheet that contained a pivot created using Nectari and a pivot created in Excel would cause an error. 13200

Web Client Templates

Template	Change description
Sage Intacct	- Fixed an issue where the consolidation module was not balancing due to Cumulative Translation Adjustment (CTA) accounts missing.
Sage X3	- Fixed an issue where the reports were not tracking all historical changes with the addition of a stored procedure (HISTODUDOPEN_CALC) to the AP/AR Historical Aging data model.